Odbc Problems

[jlperezdiaz]

Scenario:

 

1) Simple script try to do a query (very simple - just for the testing)

 

2) Created odbc on windows. Tested and worked fine with Mssql and Mysql from ODBC forms in windows.

 

3) It faill from voiceguide with both (Mssql and Mysql)

 

4) With ethereal I´ve seen there is connection with the database in both Mssql and Mysql but it fails when it tries de query

 

5) Config of the properties on voice of the Database Control (I´ve changed many options but no difference)

CSDU3

ODBC;DSN=CSDU3;UID=abcde;PWD=xyzdef;srv=192.168.25.153

select * from pin;

 

6) These are the traces

072356.17 4 matching path was found

072356.52 4 fn RunModule start [Database Query,[saldo_Cliente],3,,]

072356.55 4 timer clear

072356.58 4 state [saldo_Cliente] DB Query

072356.61 4 db ODBC mode used

072356.67 4 ERROR 6.0.3160 OpenDatabase [76:Path not found]

072356.69 4 path {76} not found

072356.72 4 path {Path not found} not found

072356.75 4 next module is [HangupCall] (idx=2)

072356.78 4 fn RunModule start [Hangup the Call,[HangupCall],2,,]

072356.81 4 timer clear

 

7) I´ve tried with Mysql with the latest odbc and the previous one. But as I´ve said it fails withe SQL Server too.

 

8) We are working with a Windows 2000 server / with all the upgrades,etc...

 

Note: we have other voiceguide system working with 9 months older release working with no problem.

 

This is related with the latest release.

 

 

Any clue about what it could be the reason? I´m lost.

 

Many thanks in advance.

 

 

José Luis

[SupportTeam]

Can you post the script you are using?

 

Have you tried leaving the database name blank and just using the Connect string?

 

Another option is to try the Database query from a VBScript - there are some samples on how to do this in the Help file.

[jlperezdiaz]

1) Script: Basically it´s just for testing the database connection.

 

Version=5.0

DefaultModuleDisplayHeight=

StartModule=MVNO_IVR

RunAtHangup=

StartWithoutAnswer=1

CtmAsiName=

 

[MVNO_IVR]

Type=Evaluate

DispSize=69

Txt=Evaluate the Result Variable specified, and select the path which matches the current value of the Result Variable

Expression=$RV[DNIS]

ExprNewRV=

ExprStoreRV=0

ExprStoreInGlobalRV=0

on {800007599} goto [saldo_Cliente]

on {901007599} goto [HangupCall]

on {902007599} goto [saldo_Cliente]

on {true} goto [HangupCall]

on {false} goto [HangupCall]

 

Position=460,72

 

[HangupCall]

Type=Hangup the Call

DispSize=69

Txt=Hangup the call.

 

Position=453,534

 

[saldo_Cliente]

Type=Database Query

DispSize=69

Txt=Search the database for data. You can then use the returned results later in your script (see Result Variables), eg: in the Say Number module or as parameters to the program calles in a Run Program module.

DbDatabase=CSDU3

DbUser=

DbConnectString=ODBC;DSN=CSDU3;UID=raquel;PWD=rakel;srv=192.168.25.153

DbSql=select * from pin;

on {success} goto [Transfer_Call]

on {fail} goto [HangupCall]

 

Position=630,214

 

[say Numbers 188]

Type=Say Numbers

DispSize=69

Txt=Say the number, amount, date or the digits. See the list o options to see how the number supplied can be interpreted and spoken out...

Replay=2,5

SayNbrType=

 

Position=640,361

 

[Transfer_Call]

Type=Transfer Call

DispSize=69

Txt=Transfer call to the selected extension.

strXferDestExt=918290100

iXferType=31

sXfer2ndLegLinesListFile=

sXferPlayWhileDialing=

sXferAnnounceMsg=

 

Position=912,248

 

 

2) If we leave the database name in blank does the same.

It appears the same message on the logs

 

094840.67 4 next module is [saldo_Cliente] (idx=8)

094840.67 4 matching path was found

094840.69 4 fn RunModule start [Database Query,[saldo_Cliente],8,,]

094840.69 4 timer clear

094840.69 4 state [saldo_Cliente] DB Query

094840.70 4 db ODBC mode used

094840.73 4 ERROR 6.0.3160 OpenDatabase [76:Path not found]

094840.73 4 path {76} not found

094840.75 4 path {Path not found} not found

094840.75 4 next module is [HangupCall] (idx=7)

094840.75 4 fn RunModule start [Hangup the Call,[HangupCall],7,,]

094840.77 4 timer clear

094840.77 4 state [HangupCall] Hangup Call

094840.77 4 HangupCall start (Hangup Module)

 

3) I will try, although I don´t have a big experience with VBscript

[jlperezdiaz]

We are still having problems connecting with odbc.

 

a) we are using the software (originally downloaded as trial from your web)

232249.41 2 db ODBC mode used

232249.45 2 ERROR 6.0.3160 OpenDatabase [76:Path not found]

232249.45 2 path {76} not found

 

DO WE NEED OTHER VOICEGUIDE VERSION TO INSTALL?

 

We have not installed anything else the operative system (win2000 server) + all the updates for windows web page + net 2.0 framework + all dialogic 5.1 + dialogic 5.1 service pack1.

 

DO WE NEED TO INSTALL ANY OTHER SW OR LIBRARIES,ETC...?

 

c) We have tested through clients the odbc connectivity is right (with sql server and with mysql), but it fails with voiceguide from the scripts.

It´s curious with ethereal in the same server we can see it´s connecting to the database right, but it doesn´t execute the query.

 

ANY INCOMPATIBILITY WE COULD TRY TO FIND?

 

We have begin using same config in other systems with other apps are working with your previous releases.

 

OUR FEELING IS PERHAPS WE HAVE NOT INSTALLED SOMETHING IS REQUIRED, BUT WE ARE LOST.

 

WE WOULD APPRECIATE YOUR HELP.

 

 

BEST REGARDS